USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Worker_Create]    Script Date: 02/10/2012 11:17:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[Worker_Create]
	@workersSalaryID		NVARCHAR(225),
	@fullName				nvarchar(50),
	@ManDate				float,
	@salary					bigint,
	@totalSalary            bigint,
	@position				nvarchar(125)
     
AS
	 DECLARE @createDate	DATETIME
     SET     @createDate = GETDATE()
BEGIN
	INSERT INTO Worker 
			(WorkersSalaryID,FullName,ManDate,Salary, 
			TotalSalary,Position)
	VALUES	(@workersSalaryID,@fullName,@ManDate,
			@salary,@totalSalary, @position)	
END
SELECT  IDENT_CURRENT('Worker')


GO

